home *** CD-ROM | disk | FTP | other *** search
/ CD Ware Multimedia 1995 May / cd Ware (Juegos) Epimundo.iso / WIN / VB_DB / PROFIT.ZIP / RECIPEBT.BAS < prev    next >
Encoding:
BASIC Source File  |  1993-03-15  |  10.0 KB  |  316 lines

  1.    '****************************************************************
  2.    '*    Recipe file type                                      *
  3.    '****************************************************************
  4.  
  5.     Type RecipeType
  6.         RecNo            As String * 6
  7.         RecDesc          As String * 30
  8.         RecGroup         As String * 4
  9.         RecRetail        As Integer
  10.         Servings         As Integer
  11.         UpdateFlag       As String * 1
  12.         TargetProfit     As Single
  13.         MaintenanceCode  As String * 1
  14.         ShelfLifeDays    As Integer
  15.     End Type
  16.  
  17.     Type RecipeDetType
  18.         RecDetKey        As String * 21
  19.           'Composed of
  20.           'RecNo            As String * 6
  21.           'IngKey           As String * 15     (Key1)
  22.              'Composed of
  23.              'SupplierNo       As String * 3
  24.              'IngredientNo     As String * 12
  25.         RecDetQty           As Double
  26.     End Type
  27.  
  28.     Global RecipeRec As RecipeType
  29.     Global RecipeSaveRec As RecipeType
  30.     Global RecipeSt%
  31.     Global RecipeKeyB$
  32.     Global RecipePosBlk As PosBlk
  33.  
  34.     Global RecipeDetRec As RecipeDetType
  35.     Global RecipeDetSaveRec As RecipeDetType
  36.     Global RecipeDetSt%
  37.     Global RecipeDetKeyB$
  38.     Global RecipeDetPosBlk As PosBlk
  39.  
  40. '**************************************************************************
  41. '*                     Begin Recipe Header Subroutines                    *
  42. '**************************************************************************
  43.  
  44. '**************************************************************************
  45. '*                     Begin Recipe Detail Subroutines                    *
  46. '**************************************************************************
  47.  
  48. Sub CloseRecipeDetFile ()
  49.     RecipeDetKeyBufLen% = 255
  50.     RecipeDetBufLen% = Len(RecipeDetRec)
  51.     KeyNum% = 0
  52.     RecipeDetSt% = 0
  53.     RecipeDetSt% = btrcall(BCLOSE, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  54. End Sub
  55.  
  56. Sub CloseRecipeFile ()
  57.     RecipeKeyBufLen% = 255
  58.     RecipeBufLen% = Len(RecipeRec)
  59.     KeyNum% = 0
  60.     RecipeSt% = 0
  61.     RecipeSt% = btrcall(BCLOSE, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  62. End Sub
  63.  
  64. Sub DeleteRecipe ()
  65.       RecipeKeyBufLen% = 255
  66.       RecipeBufLen% = Len(RecipeRec)
  67.       KeyNum% = 0
  68.       RecipeSt% = 0
  69.       RecipeSt% = btrcall(BDELETE, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  70. End Sub
  71.  
  72. Sub DeleteRecipeDet ()
  73.       RecipeDetKeyBufLen% = 255
  74.       RecipeDetBufLen% = Len(RecipeDetRec)
  75.       KeyNum% = 0
  76.       RecipeDetSt% = 0
  77.       RecipeDetSt% = btrcall(BDELETE, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  78. End Sub
  79.  
  80. Sub FirstRecipe ()
  81.   If Len(RecipeKeyB$) <> 6 Then
  82.     RecipeKeyB$ = String$(6, " ")
  83.   End If
  84.   RecipeKeyBufLen% = 255
  85.   RecipeBufLen% = Len(RecipeRec)
  86.   KeyNum% = 0
  87.   RecipeSt% = 0
  88.   RecipeSt% = btrcall(BFIRST, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  89. End Sub
  90.  
  91. Sub FirstRecipeDet ()
  92.   If Len(RecipeDetKeyB$) <> 21 Then
  93.     RecipeDetKeyB$ = String$(21, " ")
  94.   End If
  95.   RecipeDetKeyBufLen% = 255
  96.   RecipeDetBufLen% = Len(RecipeDetRec)
  97.   KeyNum% = 0
  98.   RecipeDetSt% = 0
  99.   RecipeDetSt% = btrcall(BFIRST, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  100. End Sub
  101.  
  102. Sub FirstRecipeKey1 ()
  103.   If Len(RecipeKeyB$) <> 10 Then
  104.     RecipeKeyB$ = String$(10, " ")
  105.   End If
  106.   RecipeKeyBufLen% = 255
  107.   RecipeBufLen% = Len(RecipeRec)
  108.   KeyNum% = 1
  109.   RecipeSt% = 0
  110.   RecipeSt% = btrcall(BFIRST, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  111. End Sub
  112.  
  113. Sub GetGERecipeDet ()
  114.   RecipeDetKeyB$ = RecipeDetRec.RecDetKey
  115.   RecipeDetKeyBufLen% = 255
  116.   RecipeDetBufLen% = Len(RecipeDetRec)
  117.   KeyNum% = 0
  118.   RecipeDetSt% = 0
  119.   RecipeDetSt% = btrcall(BGETGE, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  120. End Sub
  121.  
  122. Sub MsgRecipeDetDuplicate ()
  123.   Msg$ = "Ingredient is already in this recipe."
  124.   T1% = MsgBox(Msg$, 0, "Note!")
  125. End Sub
  126.  
  127. Sub MsgRecipeDetNotFound ()
  128.   Msg$ = "Recipe Detail not found.  Status = " + Str$(RecipeDetSt%)
  129.   T1% = MsgBox(Msg$, 0, "Warning!")
  130. End Sub
  131.  
  132. Sub MsgRecipeDetNotOpen ()
  133.         Msg$ = "Recipe Detail file not opened."
  134.         T1% = MsgBox(Msg$, 0, "Warning!")
  135. End Sub
  136.  
  137. Sub MsgRecipeNotFound ()
  138.   Msg$ = "Recipe not found.  Status = " + Str$(RecipeSt%)
  139.   T1% = MsgBox(Msg$, 0, "Warning!")
  140. End Sub
  141.  
  142. Sub MsgRecipeNotOpen ()
  143.         Msg$ = "Recipe file not opened."
  144.         T1% = MsgBox(Msg$, 0, "Warning!")
  145. End Sub
  146.  
  147. Sub MsgUnknownRecipeDetError ()
  148.   Msg$ = "Recipe Detail file error.  Status = " + Str$(RecipeDetSt%)
  149.   T1% = MsgBox(Msg$, 0, "Warning!")
  150. End Sub
  151.  
  152. Sub MsgUnknownRecipeError ()
  153.   Msg$ = "Recipe file error.  Status = " + Str$(RecipeSt%)
  154.   T1% = MsgBox(Msg$, 0, "Warning!")
  155. End Sub
  156.  
  157. Sub NextRecipe ()
  158.   If Len(RecipeKeyB$) <> 6 Then
  159.     RecipeKeyB$ = String$(6, " ")
  160.   End If
  161.   RecipeKeyBufLen% = 255
  162.   RecipeBufLen% = Len(RecipeRec)
  163.   KeyNum% = 0
  164.   RecipeSt% = 0
  165.   RecipeSt% = btrcall(BNEXT, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  166. End Sub
  167.  
  168. Sub NextRecipeDet ()
  169.   If Len(RecipeDetKeyB$) <> 21 Then
  170.     RecipeDetKeyB$ = String$(21, " ")
  171.   End If
  172.   RecipeDetKeyBufLen% = 255
  173.   RecipeDetBufLen% = Len(RecipeDetRec)
  174.   KeyNum% = 0
  175.   RecipeDetSt% = 0
  176.   RecipeDetSt% = btrcall(BNEXT, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  177. End Sub
  178.  
  179. Sub NextRecipeDetKey1 ()
  180.   If Len(RecipeDetKeyB$) <> 15 Then
  181.     RecipeDetKeyB$ = String$(15, " ")
  182.   End If
  183.   RecipeDetKeyBufLen% = 255
  184.   RecipeDetBufLen% = Len(RecipeDetRec)
  185.   KeyNum% = 1
  186.   RecipeDetSt% = 0
  187.   RecipeDetSt% = btrcall(BNEXT, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  188. End Sub
  189.  
  190. Sub NextRecipeKey1 ()
  191.   If Len(RecipeKeyB$) <> 10 Then
  192.     RecipeKeyB$ = String$(10, " ")
  193.   End If
  194.   RecipeKeyBufLen% = 255
  195.   RecipeBufLen% = Len(RecipeRec)
  196.   KeyNum% = 1
  197.   RecipeSt% = 0
  198.   RecipeSt% = btrcall(BNEXT, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  199. End Sub
  200.  
  201. Sub OpenRecipeDetFile ()
  202.     RecipeDetKeyB$ = "recdfile.btr"
  203.     RecipeDetKeyBufLen% = 255
  204.     RecipeDetBufLen% = Len(RecipeDetRec)
  205.     KeyNum% = 0
  206.     RecipeDetSt% = 0
  207.     RecipeDetSt% = btrcall(BOPEN, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  208.     If RecipeDetSt% <> 0 Then
  209.       Msg$ = "RecipeDet file open failed. Status = " + Str$(RecipeDetSt%)
  210.       T1% = MsgBox(Msg$, 0, "Warning!")
  211.     End If
  212. End Sub
  213.  
  214. Sub OpenRecipeFile ()
  215.     RecipeKeyB$ = "rechfile.btr"
  216.     RecipeKeyBufLen% = 255
  217.     RecipeBufLen% = Len(RecipeRec)
  218.     KeyNum% = 0
  219.     RecipeSt% = 0
  220.     RecipeSt% = btrcall(BOPEN, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  221.     If RecipeSt% <> 0 Then
  222.       Msg$ = "Recipe file open failed. Status = " + Str$(RecipeSt%)
  223.       T1% = MsgBox(Msg$, 0, "Warning!")
  224.     End If
  225. End Sub
  226.  
  227. Sub PreviousRecipe ()
  228.   If Len(RecipeKeyB$) <> 6 Then
  229.     RecipeKeyB$ = String$(6, " ")
  230.   End If
  231.   RecipeKeyBufLen% = 255
  232.   RecipeBufLen% = Len(RecipeRec)
  233.   KeyNum% = 0
  234.   RecipeSt% = 0
  235.   RecipeSt% = btrcall(BPREVIOUS, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  236. End Sub
  237.  
  238. Sub PreviousRecipeDet ()
  239.   If Len(RecipeDetKeyB$) <> 21 Then
  240.     RecipeDetKeyB$ = String$(21, " ")
  241.   End If
  242.   RecipeDetKeyBufLen% = 255
  243.   RecipeDetBufLen% = Len(RecipeDetRec)
  244.   KeyNum% = 0
  245.   RecipeDetSt% = 0
  246.   RecipeDetSt% = btrcall(BPREVIOUS, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  247. End Sub
  248.  
  249. Sub ReadRecipe ()
  250.     RecipeKeyB$ = RecipeRec.RecNo
  251.     RecipeKeyBufLen% = 255
  252.     RecipeBufLen% = Len(RecipeRec)
  253.     KeyNum% = 0
  254.     RecipeSt% = 0
  255.     RecipeSt% = btrcall(BEQUAL, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  256. End Sub
  257.  
  258. Sub ReadRecipeDet ()
  259.     RecipeDetKeyB$ = RecipeDetRec.RecDetKey
  260.     RecipeDetKeyBufLen% = 255
  261.     RecipeDetBufLen% = Len(RecipeDetRec)
  262.     KeyNum% = 0
  263.     RecipeDetSt% = 0
  264.     RecipeDetSt% = btrcall(BEQUAL, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  265. End Sub
  266.  
  267. Sub ReadRecipeDetKey1 ()
  268.     RecipeDetKeyB$ = Mid$(RecipeDetRec.RecDetKey, 7, 15)
  269.     RecipeDetKeyBufLen% = 255
  270.     RecipeDetBufLen% = Len(RecipeDetRec)
  271.     KeyNum% = 1
  272.     RecipeDetSt% = 0
  273.     RecipeDetSt% = btrcall(BEQUAL, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  274. End Sub
  275.  
  276. Sub UpdateRecipe ()
  277.     RecipeKeyBufLen% = 255
  278.     RecipeBufLen% = Len(RecipeRec)
  279.     KeyNum% = 0
  280.     RecipeSt% = 0
  281.     RecipeSt% = btrcall(BUPDATE, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  282. End Sub
  283.  
  284. Sub UpdateRecipeDet ()
  285.     RecipeDetKeyBufLen% = 255
  286.     RecipeDetBufLen% = Len(RecipeDetRec)
  287.     KeyNum% = 0
  288.     RecipeDetSt% = 0
  289.     RecipeDetSt% = btrcall(BUPDATE, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  290. End Sub
  291.  
  292. Sub UpdateRecipeDetKey1 ()
  293.     RecipeDetKeyBufLen% = 255
  294.     RecipeDetBufLen% = Len(RecipeDetRec)
  295.     KeyNum% = 1
  296.     RecipeDetSt% = 0
  297.     RecipeDetSt% = btrcall(BUPDATE, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  298. End Sub
  299.  
  300. Sub WriteRecipe ()
  301.       RecipeKeyBufLen% = 255
  302.       RecipeBufLen% = Len(RecipeRec)
  303.       KeyNum% = 0
  304.       RecipeSt% = 0
  305.       RecipeSt% = btrcall(BINSERT, RecipePosBlk, RecipeRec, RecipeBufLen%, RecipeKeyB$, RecipeKeyBufLen%, KeyNum%)
  306. End Sub
  307.  
  308. Sub WriteRecipeDet ()
  309.       RecipeDetKeyBufLen% = 255
  310.       RecipeDetBufLen% = Len(RecipeDetRec)
  311.       KeyNum% = 0
  312.       RecipeDetSt% = 0
  313.       RecipeDetSt% = btrcall(BINSERT, RecipeDetPosBlk, RecipeDetRec, RecipeDetBufLen%, RecipeDetKeyB$, RecipeDetKeyBufLen%, KeyNum%)
  314. End Sub
  315.  
  316.